{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "cb7f2094",
   "metadata": {},
   "source": [
    "* 备注\n",
    "> 1.城市： '北京、 '上海'、 '广州'、'深圳'       \n",
    "> 2.行业：广告行业              \n",
    "> 2.关键词：4A广告公司，广告策划，广告文案，营销策划类广告人才                         \n",
    "> 3.学历：本科及本科以上             "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b599a094",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "登录cookie XSRF-TOKEN=zIARnRM0QQaLudJk_4OBXw; __gc_id=e936feed5bd343e5a73b304fa0d4ad5f; _ga=GA1.1.504776059.1697021947; __uuid=1697021948310.51; __tlog=1697021948354.48%7C00000000%7C00000000%7C00000000%7C00000000; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1697021951; acw_tc=2760828416970219810274366e53a098388abcfc886c89f5cbf2332344893f; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1697021975; __session_seq=4; __uv_seq=4; __tlg_event_seq=24; _ga_54YTJKWN86=GS1.1.1697021946.1.1.1697023027.0.0.0\n",
      "这是第1页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待8秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待7秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待5秒...然后以继续抓取\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.advViewFlag</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.link</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"recruiterName\":\"徐女士\",\"userId\":\"18e915d98549c...</td>\n",
       "      <td>[客户管理, 市场洞察, 自动化行业]</td>\n",
       "      <td>南京</td>\n",
       "      <td>True</td>\n",
       "      <td>20231008144219</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>销售经理（电力电气）</td>\n",
       "      <td>https://www.liepin.com/job/1961137359.shtml</td>\n",
       "      <td>...</td>\n",
       "      <td>18e915d98549c42b7f48a16331dbb13e</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>南京国臣直流配电科技有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>60b58ddbca392a3b179c542106u.png</td>\n",
       "      <td>12765383</td>\n",
       "      <td>https://www.liepin.com/company/12765383/</td>\n",
       "      <td>新能源</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"recruiterName\":\"陈女士\",\"userId\":\"6b7081e7d3932...</td>\n",
       "      <td>[]</td>\n",
       "      <td>苏州</td>\n",
       "      <td>True</td>\n",
       "      <td>20231129150804</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>QC工程师</td>\n",
       "      <td>https://www.liepin.com/job/1962948663.shtml</td>\n",
       "      <td>...</td>\n",
       "      <td>6b7081e7d3932ce3a11de16b8c4529a0</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>苏州徕瑞医疗技术有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5f87e2e479c7cc70efbbaa2e05u.png</td>\n",
       "      <td>10286591</td>\n",
       "      <td>https://www.liepin.com/company/10286591/</td>\n",
       "      <td>医疗器械</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"recruiterName\":\"彭女士\",\"userId\":\"8f7e8006d1157...</td>\n",
       "      <td>[员工关系]</td>\n",
       "      <td>广州-黄埔区</td>\n",
       "      <td>True</td>\n",
       "      <td>20231129104642</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>招聘主管</td>\n",
       "      <td>https://www.liepin.com/job/1911629114.shtml</td>\n",
       "      <td>...</td>\n",
       "      <td>8f7e8006d1157938ce0edade27e99439</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>广州英赛特生物技术有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5c820ad7261c45f047a3883707u.png</td>\n",
       "      <td>1523635</td>\n",
       "      <td>https://www.liepin.com/company/1523635/</td>\n",
       "      <td>农/林/牧/渔</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"recruiterName\":\"任女士\",\"userId\":\"5f1d8d6cdef0c...</td>\n",
       "      <td>[本科, Java, 后端开发, 前端开发, 全栈开发]</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129203303</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>Java（校招，上海）</td>\n",
       "      <td>https://www.liepin.com/lptjob/63288279</td>\n",
       "      <td>...</td>\n",
       "      <td>5f1d8d6cdef0c8ebda6076b94f5ee766</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>西安华为</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>5e7f752337483e328d69ac0508u.jpg</td>\n",
       "      <td>9808727</td>\n",
       "      <td>https://www.liepin.com/company/9808727/</td>\n",
       "      <td>云计算/大数据</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"recruiterName\":\"李先生\",\"userId\":\"472d809a08a85...</td>\n",
       "      <td>[本科]</td>\n",
       "      <td>上海-长宁区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129202032</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>企业文化专员</td>\n",
       "      <td>https://www.liepin.com/lptjob/63288217</td>\n",
       "      <td>...</td>\n",
       "      <td>472d809a08a858d96693698b2a4a87d0</td>\n",
       "      <td>5f8f9868f6d1ab58476f24a008u.jpg</td>\n",
       "      <td>GNC</td>\n",
       "      <td>战略投资</td>\n",
       "      <td>5d5e4526d0718579c6cacda806u.jpg</td>\n",
       "      <td>7950181</td>\n",
       "      <td>https://www.liepin.com/company/7950181/</td>\n",
       "      <td>食品/饮料/酒水</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...</td>\n",
       "      <td>{\"jobId\":\"63262423\",\"imId\":\"9928b0297187bcd1ab...</td>\n",
       "      <td>[本科, 跨境电商平台, 账号运营]</td>\n",
       "      <td>重庆-渝中区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129101901</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>新媒体运营实习生</td>\n",
       "      <td>https://www.liepin.com/lptjob/63262423</td>\n",
       "      <td>...</td>\n",
       "      <td>0b61c006df76dfdab798f3dfacfc5ba6</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>大龙网集团</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5fc72d857d6477448761e43d01u.png</td>\n",
       "      <td>987631</td>\n",
       "      <td>https://www.liepin.com/company/987631/</td>\n",
       "      <td>互联网</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...</td>\n",
       "      <td>{\"jobId\":\"63262323\",\"imId\":\"448510904e29023fdf...</td>\n",
       "      <td>[本科]</td>\n",
       "      <td>绍兴-越城区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129101722</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>采购工程师（2024届）（J10183）</td>\n",
       "      <td>https://www.liepin.com/lptjob/63262323</td>\n",
       "      <td>...</td>\n",
       "      <td>656c9fdb9e8ab64a4e8769deb5792c4e</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>绍兴中芯集成电路制造股份有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62a157fa5e2004670dde281a08u.png</td>\n",
       "      <td>9761593</td>\n",
       "      <td>https://www.liepin.com/company/9761593/</td>\n",
       "      <td>电子/半导体/集成电路</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...</td>\n",
       "      <td>{\"jobId\":\"63262283\",\"imId\":\"208084d068656c515c...</td>\n",
       "      <td>[3个月, 提供转正, 本科]</td>\n",
       "      <td>重庆-江津区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129101652</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>生产实习生</td>\n",
       "      <td>https://www.liepin.com/lptjob/63262283</td>\n",
       "      <td>...</td>\n",
       "      <td>b10ccd7fc8ba8186e5416f2c4b7e93f5</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>重庆标能瑞源储能技术研究院有限公司</td>\n",
       "      <td>其他</td>\n",
       "      <td>640993c0f8732420a170133202u.png</td>\n",
       "      <td>12733099</td>\n",
       "      <td>https://www.liepin.com/company/12733099/</td>\n",
       "      <td>新能源</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...</td>\n",
       "      <td>{\"jobId\":\"63262235\",\"imId\":\"afa6601d8172227f45...</td>\n",
       "      <td>[3个月, 本科]</td>\n",
       "      <td>北京-海淀区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129103552</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>内容运营实习生</td>\n",
       "      <td>https://www.liepin.com/lptjob/63262235</td>\n",
       "      <td>...</td>\n",
       "      <td>a5538f5b58fbb717d459402d81d61182</td>\n",
       "      <td>653791513da96b09ca009b3c05u.png</td>\n",
       "      <td>中科院创业投资管理有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5bfea2a974719d2aa34c649203a.png</td>\n",
       "      <td>9374707</td>\n",
       "      <td>https://www.liepin.com/company/9374707/</td>\n",
       "      <td>基金/证券/期货</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...</td>\n",
       "      <td>{\"jobId\":\"63262207\",\"imId\":\"0506aed120042a2b41...</td>\n",
       "      <td>[本科]</td>\n",
       "      <td>西安-高新区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129101547</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>基站软件开发工程师</td>\n",
       "      <td>https://www.liepin.com/lptjob/63262207</td>\n",
       "      <td>...</td>\n",
       "      <td>ab00cb03daf14c52be6e01fc044e8f5d</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>Baicells 佰才邦</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5e99133b5a1a60079d71749505u.jpg</td>\n",
       "      <td>8263211</td>\n",
       "      <td>https://www.liepin.com/company/8263211/</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "1   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "2   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "3   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "4   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "..                                                ...   \n",
       "35  %7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...   \n",
       "36  %7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...   \n",
       "37  %7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...   \n",
       "38  %7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...   \n",
       "39  %7B%22ckId%22%3A%22y2jy1uvl2gar8xipyemg77rijoo...   \n",
       "\n",
       "                                           dataParams  \\\n",
       "0   {\"recruiterName\":\"徐女士\",\"userId\":\"18e915d98549c...   \n",
       "1   {\"recruiterName\":\"陈女士\",\"userId\":\"6b7081e7d3932...   \n",
       "2   {\"recruiterName\":\"彭女士\",\"userId\":\"8f7e8006d1157...   \n",
       "3   {\"recruiterName\":\"任女士\",\"userId\":\"5f1d8d6cdef0c...   \n",
       "4   {\"recruiterName\":\"李先生\",\"userId\":\"472d809a08a85...   \n",
       "..                                                ...   \n",
       "35  {\"jobId\":\"63262423\",\"imId\":\"9928b0297187bcd1ab...   \n",
       "36  {\"jobId\":\"63262323\",\"imId\":\"448510904e29023fdf...   \n",
       "37  {\"jobId\":\"63262283\",\"imId\":\"208084d068656c515c...   \n",
       "38  {\"jobId\":\"63262235\",\"imId\":\"afa6601d8172227f45...   \n",
       "39  {\"jobId\":\"63262207\",\"imId\":\"0506aed120042a2b41...   \n",
       "\n",
       "                      job.labels   job.dq  job.topJob job.refreshTime  \\\n",
       "0            [客户管理, 市场洞察, 自动化行业]       南京        True  20231008144219   \n",
       "1                             []       苏州        True  20231129150804   \n",
       "2                         [员工关系]   广州-黄埔区        True  20231129104642   \n",
       "3   [本科, Java, 后端开发, 前端开发, 全栈开发]  上海-浦东新区       False  20231129203303   \n",
       "4                           [本科]   上海-长宁区       False  20231129202032   \n",
       "..                           ...      ...         ...             ...   \n",
       "35            [本科, 跨境电商平台, 账号运营]   重庆-渝中区       False  20231129101901   \n",
       "36                          [本科]   绍兴-越城区       False  20231129101722   \n",
       "37               [3个月, 提供转正, 本科]   重庆-江津区       False  20231129101652   \n",
       "38                     [3个月, 本科]   北京-海淀区       False  20231129103552   \n",
       "39                          [本科]   西安-高新区       False  20231129101547   \n",
       "\n",
       "   job.jobKind  job.advViewFlag             job.title  \\\n",
       "0            2             True            销售经理（电力电气）   \n",
       "1            2             True                 QC工程师   \n",
       "2            2             True                  招聘主管   \n",
       "3            6            False           Java（校招，上海）   \n",
       "4            6            False                企业文化专员   \n",
       "..         ...              ...                   ...   \n",
       "35           6            False              新媒体运营实习生   \n",
       "36           6            False  采购工程师（2024届）（J10183）   \n",
       "37           6            False                 生产实习生   \n",
       "38           6            False               内容运营实习生   \n",
       "39           6            False             基站软件开发工程师   \n",
       "\n",
       "                                       job.link  ...  \\\n",
       "0   https://www.liepin.com/job/1961137359.shtml  ...   \n",
       "1   https://www.liepin.com/job/1962948663.shtml  ...   \n",
       "2   https://www.liepin.com/job/1911629114.shtml  ...   \n",
       "3        https://www.liepin.com/lptjob/63288279  ...   \n",
       "4        https://www.liepin.com/lptjob/63288217  ...   \n",
       "..                                          ...  ...   \n",
       "35       https://www.liepin.com/lptjob/63262423  ...   \n",
       "36       https://www.liepin.com/lptjob/63262323  ...   \n",
       "37       https://www.liepin.com/lptjob/63262283  ...   \n",
       "38       https://www.liepin.com/lptjob/63262235  ...   \n",
       "39       https://www.liepin.com/lptjob/63262207  ...   \n",
       "\n",
       "               recruiter.recruiterId         recruiter.recruiterPhoto  \\\n",
       "0   18e915d98549c42b7f48a16331dbb13e  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "1   6b7081e7d3932ce3a11de16b8c4529a0  5f8f9865ea60860b75384fa508u.jpg   \n",
       "2   8f7e8006d1157938ce0edade27e99439  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "3   5f1d8d6cdef0c8ebda6076b94f5ee766  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "4   472d809a08a858d96693698b2a4a87d0  5f8f9868f6d1ab58476f24a008u.jpg   \n",
       "..                               ...                              ...   \n",
       "35  0b61c006df76dfdab798f3dfacfc5ba6  5f8f9865ea60860b75384fa508u.jpg   \n",
       "36  656c9fdb9e8ab64a4e8769deb5792c4e  5f8f98648dbe6273dcf8515508u.jpg   \n",
       "37  b10ccd7fc8ba8186e5416f2c4b7e93f5  5f8f98648dbe6273dcf8515508u.jpg   \n",
       "38  a5538f5b58fbb717d459402d81d61182  653791513da96b09ca009b3c05u.png   \n",
       "39  ab00cb03daf14c52be6e01fc044e8f5d  5f8f986779c7cc70efbf36c008u.jpg   \n",
       "\n",
       "        comp.compName comp.compStage                    comp.compLogo  \\\n",
       "0      南京国臣直流配电科技有限公司          融资未公开  60b58ddbca392a3b179c542106u.png   \n",
       "1        苏州徕瑞医疗技术有限公司            NaN  5f87e2e479c7cc70efbbaa2e05u.png   \n",
       "2       广州英赛特生物技术有限公司            NaN  5c820ad7261c45f047a3883707u.png   \n",
       "3                西安华为          融资未公开  5e7f752337483e328d69ac0508u.jpg   \n",
       "4                 GNC           战略投资  5d5e4526d0718579c6cacda806u.jpg   \n",
       "..                ...            ...                              ...   \n",
       "35              大龙网集团            NaN  5fc72d857d6477448761e43d01u.png   \n",
       "36   绍兴中芯集成电路制造股份有限公司            NaN  62a157fa5e2004670dde281a08u.png   \n",
       "37  重庆标能瑞源储能技术研究院有限公司             其他  640993c0f8732420a170133202u.png   \n",
       "38      中科院创业投资管理有限公司            NaN  5bfea2a974719d2aa34c649203a.png   \n",
       "39       Baicells 佰才邦            NaN  5e99133b5a1a60079d71749505u.jpg   \n",
       "\n",
       "   comp.compId                                 comp.link comp.compIndustry  \\\n",
       "0     12765383  https://www.liepin.com/company/12765383/               新能源   \n",
       "1     10286591  https://www.liepin.com/company/10286591/              医疗器械   \n",
       "2      1523635   https://www.liepin.com/company/1523635/           农/林/牧/渔   \n",
       "3      9808727   https://www.liepin.com/company/9808727/           云计算/大数据   \n",
       "4      7950181   https://www.liepin.com/company/7950181/          食品/饮料/酒水   \n",
       "..         ...                                       ...               ...   \n",
       "35      987631    https://www.liepin.com/company/987631/               互联网   \n",
       "36     9761593   https://www.liepin.com/company/9761593/       电子/半导体/集成电路   \n",
       "37    12733099  https://www.liepin.com/company/12733099/               新能源   \n",
       "38     9374707   https://www.liepin.com/company/9374707/          基金/证券/期货   \n",
       "39     8263211   https://www.liepin.com/company/8263211/              通信设备   \n",
       "\n",
       "   comp.compScale  job.campusJobKind  \n",
       "0        100-499人                NaN  \n",
       "1          50-99人                NaN  \n",
       "2        100-499人                NaN  \n",
       "3        10000人以上                 应届  \n",
       "4        100-499人                 应届  \n",
       "..            ...                ...  \n",
       "35       500-999人                 应届  \n",
       "36     2000-5000人                 应届  \n",
       "37       100-499人                 实习  \n",
       "38         50-99人                 实习  \n",
       "39       100-499人                 应届  \n",
       "\n",
       "[400 rows x 32 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "\n",
    "crawl_liepin.crawl(城市=\"\",关键词=\"\",学历= \"\",行业=\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d3045127",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "登录cookie XSRF-TOKEN=zIARnRM0QQaLudJk_4OBXw; __gc_id=e936feed5bd343e5a73b304fa0d4ad5f; _ga=GA1.1.504776059.1697021947; __uuid=1697021948310.51; __tlog=1697021948354.48%7C00000000%7C00000000%7C00000000%7C00000000; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1697021951; acw_tc=2760828416970219810274366e53a098388abcfc886c89f5cbf2332344893f; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1697021975; __session_seq=4; __uv_seq=4; __tlg_event_seq=24; _ga_54YTJKWN86=GS1.1.1697021946.1.1.1697023027.0.0.0\n",
      "这是第1页，接下来将先等待8秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待7秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待3秒...然后以继续抓取\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.link</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...</td>\n",
       "      <td>{\"recruiterName\":\"唐女士\",\"imId\":\"f3a453fd191548a...</td>\n",
       "      <td>[公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>市场经理</td>\n",
       "      <td>2</td>\n",
       "      <td>63221469</td>\n",
       "      <td>https://www.liepin.com/job/1963221469.shtml</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20231127190756</td>\n",
       "      <td>...</td>\n",
       "      <td>6e60308e0d7e0a5d35b7122fd419b76f</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>6247ff3b3247ad31bb6a350808u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>贝克斯数字媒体技术(深圳)有限公司</td>\n",
       "      <td>https://www.liepin.com/company/13165103/</td>\n",
       "      <td>13165103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...</td>\n",
       "      <td>{\"recruiterName\":\"郑女士\",\"imId\":\"e4927366eb6aa88...</td>\n",
       "      <td>[现金管理, 财务结算, 记账凭证编制, 报表编制, 用友]</td>\n",
       "      <td>深圳-龙岗区</td>\n",
       "      <td>会计助理</td>\n",
       "      <td>2</td>\n",
       "      <td>63172317</td>\n",
       "      <td>https://www.liepin.com/job/1963172317.shtml</td>\n",
       "      <td>一年以下</td>\n",
       "      <td>20231125111354</td>\n",
       "      <td>...</td>\n",
       "      <td>07ad883867e2634acaa164b6730366d6</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>622c114ed5235a3cb077f01a08u.jpg</td>\n",
       "      <td>互联网</td>\n",
       "      <td>青橙数科集团</td>\n",
       "      <td>https://www.liepin.com/company/13155323/</td>\n",
       "      <td>13155323</td>\n",
       "      <td>A轮</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...</td>\n",
       "      <td>{\"recruiterName\":\"卢女士\",\"imId\":\"ff0eab8eea20c36...</td>\n",
       "      <td>[本科, 市场策划, 活动策划, 教育培训]</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>国际合作专员</td>\n",
       "      <td>6</td>\n",
       "      <td>63078431</td>\n",
       "      <td>https://www.liepin.com/lptjob/63078431</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20231127145532</td>\n",
       "      <td>...</td>\n",
       "      <td>31ae35dd25c393cef0498bd9e03ba548</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>65643db3aef7c833d61189e304u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>正壹会展集团</td>\n",
       "      <td>https://www.liepin.com/company/13332619/</td>\n",
       "      <td>13332619</td>\n",
       "      <td>其他</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...</td>\n",
       "      <td>{\"recruiterName\":\"宿女士\",\"imId\":\"cad5be4e96049dd...</td>\n",
       "      <td>[6个月, 本科]</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>合同管理 intern (MJ000210)</td>\n",
       "      <td>6</td>\n",
       "      <td>62439369</td>\n",
       "      <td>https://www.liepin.com/lptjob/62439369</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20231027110528</td>\n",
       "      <td>...</td>\n",
       "      <td>062818603e680b2da5f99130e9ef8d12</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>5ef7eac6639c8353865e8cfa03u.jpeg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>上海邑炎信息科技有限公司</td>\n",
       "      <td>https://www.liepin.com/company/9638001/</td>\n",
       "      <td>9638001</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...</td>\n",
       "      <td>{\"recruiterName\":\"李女士\",\"imId\":\"17cca1ce48d9b11...</td>\n",
       "      <td>[本科, 销售方向, 销售]</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>营销培训生</td>\n",
       "      <td>6</td>\n",
       "      <td>62386299</td>\n",
       "      <td>https://www.liepin.com/lptjob/62386299</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20231109094658</td>\n",
       "      <td>...</td>\n",
       "      <td>e7d4c09bd9ad172d971ee8f2edea25b2</td>\n",
       "      <td>63031de9636e1b234ac6a45505u.png</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>636c9f9f19919c4d06ca723f04u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>新潮传媒集团</td>\n",
       "      <td>https://www.liepin.com/company/9272548/</td>\n",
       "      <td>9272548</td>\n",
       "      <td>D轮</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"recruiterName\":\"姚女士\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>[EMC设计, PCB设计, 软件开发, Altium Designer, Protel, ...</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>EMC工程师</td>\n",
       "      <td>2</td>\n",
       "      <td>59638707</td>\n",
       "      <td>https://www.liepin.com/job/1959638707.shtml</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20231120092349</td>\n",
       "      <td>...</td>\n",
       "      <td>c3ad4056ce65fc5d293e71c3e8702e15</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>5bf922508e506f9e85931fdc04a.jpg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>深圳市联建光电股份有限公司</td>\n",
       "      <td>https://www.liepin.com/company/1649098/</td>\n",
       "      <td>1649098</td>\n",
       "      <td>沪深A股上市</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"recruiterName\":\"许女士\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>[视觉设计, 平面设计, VI设计, 广告设计, 品牌设计, 创意设计, 物料设计, Pho...</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>平面设计师</td>\n",
       "      <td>2</td>\n",
       "      <td>59631431</td>\n",
       "      <td>https://www.liepin.com/job/1959631431.shtml</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20230628164714</td>\n",
       "      <td>...</td>\n",
       "      <td>b039f8f2e1f20aec37f4905b207ec932</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>深圳符号逻辑设计有限公司</td>\n",
       "      <td>https://www.liepin.com/company/13591649/</td>\n",
       "      <td>13591649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"recruiterName\":\"邓女士\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>[品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>资深公关经理-金融PR出身</td>\n",
       "      <td>2</td>\n",
       "      <td>59631017</td>\n",
       "      <td>https://www.liepin.com/job/1959631017.shtml</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>20231129145826</td>\n",
       "      <td>...</td>\n",
       "      <td>fab8aadcaab02460a3029238bee39c12</td>\n",
       "      <td>6360ec960ce01330f847c0e107u.jpeg</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>6305953c28e72769b4c22fb102u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>胡润百富</td>\n",
       "      <td>https://www.liepin.com/company/7916546/</td>\n",
       "      <td>7916546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"recruiterName\":\"王先生\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>[品牌总监, 品牌顾问, 创意总监, 品牌老师, 定位咨询, 定位老师]</td>\n",
       "      <td>深圳-龙岗区</td>\n",
       "      <td>品牌咨询顾问</td>\n",
       "      <td>2</td>\n",
       "      <td>59613675</td>\n",
       "      <td>https://www.liepin.com/job/1959613675.shtml</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>20230717114859</td>\n",
       "      <td>...</td>\n",
       "      <td>3cd7c69bc663cab4af91f4d20e2eaaa8</td>\n",
       "      <td>5f8f986c79c7cc70efbf36c808u.jpg</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>5f89047aea60860b7535580107u.jpg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>非常差异品牌营销策划(深圳)有限公司</td>\n",
       "      <td>https://www.liepin.com/company/12433985/</td>\n",
       "      <td>12433985</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"recruiterName\":\"梁女士\",\"jobKind\":\"2\",\"jobId\":\"...</td>\n",
       "      <td>[市场洞察, 招投标, to G, 文旅, 文化馆, 博物馆]</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>商务专员</td>\n",
       "      <td>2</td>\n",
       "      <td>59603343</td>\n",
       "      <td>https://www.liepin.com/job/1959603343.shtml</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>20231011101422</td>\n",
       "      <td>...</td>\n",
       "      <td>05d50ebb36bc51268ca3e333b80b350e</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>5bfea16b74719d2aa34c27c803a.png</td>\n",
       "      <td>广播/影视/录音</td>\n",
       "      <td>丝路视觉</td>\n",
       "      <td>https://www.liepin.com/company/9143699/</td>\n",
       "      <td>9143699</td>\n",
       "      <td>创业板上市</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...   \n",
       "1   %7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...   \n",
       "2   %7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...   \n",
       "3   %7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...   \n",
       "4   %7B%22d_curPage%22%3A%220%22%2C%22d_pageSize%2...   \n",
       "..                                                ...   \n",
       "35  %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "36  %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "37  %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "38  %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "39  %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "\n",
       "                                           dataParams  \\\n",
       "0   {\"recruiterName\":\"唐女士\",\"imId\":\"f3a453fd191548a...   \n",
       "1   {\"recruiterName\":\"郑女士\",\"imId\":\"e4927366eb6aa88...   \n",
       "2   {\"recruiterName\":\"卢女士\",\"imId\":\"ff0eab8eea20c36...   \n",
       "3   {\"recruiterName\":\"宿女士\",\"imId\":\"cad5be4e96049dd...   \n",
       "4   {\"recruiterName\":\"李女士\",\"imId\":\"17cca1ce48d9b11...   \n",
       "..                                                ...   \n",
       "35  {\"recruiterName\":\"姚女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "36  {\"recruiterName\":\"许女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "37  {\"recruiterName\":\"邓女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "38  {\"recruiterName\":\"王先生\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "39  {\"recruiterName\":\"梁女士\",\"jobKind\":\"2\",\"jobId\":\"...   \n",
       "\n",
       "                                           job.labels  job.dq  \\\n",
       "0   [公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...  深圳-南山区   \n",
       "1                      [现金管理, 财务结算, 记账凭证编制, 报表编制, 用友]  深圳-龙岗区   \n",
       "2                              [本科, 市场策划, 活动策划, 教育培训]  深圳-福田区   \n",
       "3                                           [6个月, 本科]  深圳-南山区   \n",
       "4                                      [本科, 销售方向, 销售]  深圳-福田区   \n",
       "..                                                ...     ...   \n",
       "35  [EMC设计, PCB设计, 软件开发, Altium Designer, Protel, ...  深圳-宝安区   \n",
       "36  [视觉设计, 平面设计, VI设计, 广告设计, 品牌设计, 创意设计, 物料设计, Pho...  深圳-宝安区   \n",
       "37  [品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...  深圳-福田区   \n",
       "38               [品牌总监, 品牌顾问, 创意总监, 品牌老师, 定位咨询, 定位老师]  深圳-龙岗区   \n",
       "39                    [市场洞察, 招投标, to G, 文旅, 文化馆, 博物馆]  深圳-福田区   \n",
       "\n",
       "                 job.title job.jobKind job.jobId  \\\n",
       "0                     市场经理           2  63221469   \n",
       "1                     会计助理           2  63172317   \n",
       "2                   国际合作专员           6  63078431   \n",
       "3   合同管理 intern (MJ000210)           6  62439369   \n",
       "4                    营销培训生           6  62386299   \n",
       "..                     ...         ...       ...   \n",
       "35                  EMC工程师           2  59638707   \n",
       "36                   平面设计师           2  59631431   \n",
       "37           资深公关经理-金融PR出身           2  59631017   \n",
       "38                  品牌咨询顾问           2  59613675   \n",
       "39                    商务专员           2  59603343   \n",
       "\n",
       "                                       job.link job.requireWorkYears  \\\n",
       "0   https://www.liepin.com/job/1963221469.shtml                 3-5年   \n",
       "1   https://www.liepin.com/job/1963172317.shtml                 一年以下   \n",
       "2        https://www.liepin.com/lptjob/63078431                  NaN   \n",
       "3        https://www.liepin.com/lptjob/62439369                  NaN   \n",
       "4        https://www.liepin.com/lptjob/62386299                  NaN   \n",
       "..                                          ...                  ...   \n",
       "35  https://www.liepin.com/job/1959638707.shtml                 3-5年   \n",
       "36  https://www.liepin.com/job/1959631431.shtml                 3-5年   \n",
       "37  https://www.liepin.com/job/1959631017.shtml                 3-5年   \n",
       "38  https://www.liepin.com/job/1959613675.shtml                10年以上   \n",
       "39  https://www.liepin.com/job/1959603343.shtml                 1-3年   \n",
       "\n",
       "   job.refreshTime  ...             recruiter.recruiterId  \\\n",
       "0   20231127190756  ...  6e60308e0d7e0a5d35b7122fd419b76f   \n",
       "1   20231125111354  ...  07ad883867e2634acaa164b6730366d6   \n",
       "2   20231127145532  ...  31ae35dd25c393cef0498bd9e03ba548   \n",
       "3   20231027110528  ...  062818603e680b2da5f99130e9ef8d12   \n",
       "4   20231109094658  ...  e7d4c09bd9ad172d971ee8f2edea25b2   \n",
       "..             ...  ...                               ...   \n",
       "35  20231120092349  ...  c3ad4056ce65fc5d293e71c3e8702e15   \n",
       "36  20230628164714  ...  b039f8f2e1f20aec37f4905b207ec932   \n",
       "37  20231129145826  ...  fab8aadcaab02460a3029238bee39c12   \n",
       "38  20230717114859  ...  3cd7c69bc663cab4af91f4d20e2eaaa8   \n",
       "39  20231011101422  ...  05d50ebb36bc51268ca3e333b80b350e   \n",
       "\n",
       "            recruiter.recruiterPhoto comp.compScale  \\\n",
       "0    5f8f986779c7cc70efbf36c008u.jpg       100-499人   \n",
       "1    5f8f9866dfb13a7dee342f1808u.jpg       500-999人   \n",
       "2    5f8f986779c7cc70efbf36c008u.jpg         50-99人   \n",
       "3    5f8f9866dfb13a7dee342f1808u.jpg       100-499人   \n",
       "4    63031de9636e1b234ac6a45505u.png    5000-10000人   \n",
       "..                               ...            ...   \n",
       "35   5f8f9863f6d1ab58476f246a08u.jpg     2000-5000人   \n",
       "36   5f8f98648dbe6273dcf8515508u.jpg          1-49人   \n",
       "37  6360ec960ce01330f847c0e107u.jpeg       100-499人   \n",
       "38   5f8f986c79c7cc70efbf36c808u.jpg          1-49人   \n",
       "39   5f8f986779c7cc70efbf36c008u.jpg     2000-5000人   \n",
       "\n",
       "                       comp.compLogo comp.compIndustry       comp.compName  \\\n",
       "0    6247ff3b3247ad31bb6a350808u.png          广告/公关/会展   贝克斯数字媒体技术(深圳)有限公司   \n",
       "1    622c114ed5235a3cb077f01a08u.jpg               互联网              青橙数科集团   \n",
       "2    65643db3aef7c833d61189e304u.png          广告/公关/会展              正壹会展集团   \n",
       "3   5ef7eac6639c8353865e8cfa03u.jpeg          广告/公关/会展        上海邑炎信息科技有限公司   \n",
       "4    636c9f9f19919c4d06ca723f04u.png          广告/公关/会展              新潮传媒集团   \n",
       "..                               ...               ...                 ...   \n",
       "35   5bf922508e506f9e85931fdc04a.jpg          广告/公关/会展       深圳市联建光电股份有限公司   \n",
       "36   61b07937d0458d53c627567e02u.jpg          广告/公关/会展        深圳符号逻辑设计有限公司   \n",
       "37   6305953c28e72769b4c22fb102u.png          广告/公关/会展                胡润百富   \n",
       "38   5f89047aea60860b7535580107u.jpg          广告/公关/会展  非常差异品牌营销策划(深圳)有限公司   \n",
       "39   5bfea16b74719d2aa34c27c803a.png          广播/影视/录音                丝路视觉   \n",
       "\n",
       "                                   comp.link comp.compId comp.compStage  \\\n",
       "0   https://www.liepin.com/company/13165103/    13165103            NaN   \n",
       "1   https://www.liepin.com/company/13155323/    13155323             A轮   \n",
       "2   https://www.liepin.com/company/13332619/    13332619             其他   \n",
       "3    https://www.liepin.com/company/9638001/     9638001          融资未公开   \n",
       "4    https://www.liepin.com/company/9272548/     9272548             D轮   \n",
       "..                                       ...         ...            ...   \n",
       "35   https://www.liepin.com/company/1649098/     1649098         沪深A股上市   \n",
       "36  https://www.liepin.com/company/13591649/    13591649            NaN   \n",
       "37   https://www.liepin.com/company/7916546/     7916546            NaN   \n",
       "38  https://www.liepin.com/company/12433985/    12433985            NaN   \n",
       "39   https://www.liepin.com/company/9143699/     9143699          创业板上市   \n",
       "\n",
       "   job.campusJobKind  \n",
       "0                NaN  \n",
       "1                NaN  \n",
       "2                 应届  \n",
       "3                 实习  \n",
       "4                 应届  \n",
       "..               ...  \n",
       "35               NaN  \n",
       "36               NaN  \n",
       "37               NaN  \n",
       "38               NaN  \n",
       "39               NaN  \n",
       "\n",
       "[400 rows x 32 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "\n",
    "crawl_liepin.crawl(城市=\"深圳\",关键词=\"\",学历= \"本科\",行业=\"广告\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a90942a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; __uuid=1681902695314.85; __gc_id=5345367cb21c4298a544835e18c56d1f; need_bind_tel=false; c_flag=5b991c00b1dd3c936104eb0f28aad784; _ga=GA1.1.1004117102.1681904443; new_user=false; imId=bdd7042bddfede3f6846d40b980161c2; imId_0=bdd7042bddfede3f6846d40b980161c2; imClientId=bdd7042bddfede3f8c4e11c17165661e; imClientId_0=bdd7042bddfede3f8c4e11c17165661e; XSRF-TOKEN=ZNW_26Q9SzGF9lYv6QRPBA; __tlog=1701256347630.50%7C00000000%7C00000000%7Cs_o_007%7Cs_o_007; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1698838424,1700049509,1701256348; UniqueKey=267e69689bc2f92b6bc56763ae71c6f2; liepin_login_valid=0; lt_auth=v%2B9caXUBmlqr4Xjd3GJYsf0f24ihWGya%2FXgK0UgAhd68DvPi4P%2FmQAmPr7EE%2BCoIq0gnI6kzMLf%2BNOr7z3BC7EYV%2FVGnlZ6utf6k1XweTuxlHuyflMXuqsjQQ5wtrXo6ykpgn2si0HU%3D; access_system=C; user_roles=0; user_photo=5f8fa3baf6d1ab58476f324908u.png; user_name=%E8%B5%96%E6%96%87%E4%BD%A9; inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; hpo_role-sec_project=sec_project_liepin; hpo_sec_tenant=0; imApp_0=1; acw_tc=276077ba17012604467485820e70d4da2c9fb1aa8355e3c77ae9c748ee57af; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1701260826; fe_im_socketSequence_new_0=7_6_6; __session_seq=20; __uv_seq=20; __tlg_event_seq=286; fe_im_opened_pages=; fe_im_connectJson_0=%7B%220_267e69689bc2f92b6bc56763ae71c6f2%22%3A%7B%22socketConnect%22%3A%222%22%2C%22connectDomain%22%3A%22liepin.com%22%7D%7D; _ga_54YTJKWN86=GS1.1.1701260819.21.1.1701261828.0.0.0'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cookie = \"inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; __uuid=1681902695314.85; __gc_id=5345367cb21c4298a544835e18c56d1f; need_bind_tel=false; c_flag=5b991c00b1dd3c936104eb0f28aad784; _ga=GA1.1.1004117102.1681904443; new_user=false; imId=bdd7042bddfede3f6846d40b980161c2; imId_0=bdd7042bddfede3f6846d40b980161c2; imClientId=bdd7042bddfede3f8c4e11c17165661e; imClientId_0=bdd7042bddfede3f8c4e11c17165661e; XSRF-TOKEN=ZNW_26Q9SzGF9lYv6QRPBA; __tlog=1701256347630.50%7C00000000%7C00000000%7Cs_o_007%7Cs_o_007; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1698838424,1700049509,1701256348; UniqueKey=267e69689bc2f92b6bc56763ae71c6f2; liepin_login_valid=0; lt_auth=v%2B9caXUBmlqr4Xjd3GJYsf0f24ihWGya%2FXgK0UgAhd68DvPi4P%2FmQAmPr7EE%2BCoIq0gnI6kzMLf%2BNOr7z3BC7EYV%2FVGnlZ6utf6k1XweTuxlHuyflMXuqsjQQ5wtrXo6ykpgn2si0HU%3D; access_system=C; user_roles=0; user_photo=5f8fa3baf6d1ab58476f324908u.png; user_name=%E8%B5%96%E6%96%87%E4%BD%A9; inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; hpo_role-sec_project=sec_project_liepin; hpo_sec_tenant=0; imApp_0=1; acw_tc=276077ba17012604467485820e70d4da2c9fb1aa8355e3c77ae9c748ee57af; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1701260826; fe_im_socketSequence_new_0=7_6_6; __session_seq=20; __uv_seq=20; __tlg_event_seq=286; fe_im_opened_pages=; fe_im_connectJson_0=%7B%220_267e69689bc2f92b6bc56763ae71c6f2%22%3A%7B%22socketConnect%22%3A%222%22%2C%22connectDomain%22%3A%22liepin.com%22%7D%7D; _ga_54YTJKWN86=GS1.1.1701260819.21.1.1701261828.0.0.0\"\n",
    "cookie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "53a5c82d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "登录cookie inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; __uuid=1681902695314.85; __gc_id=5345367cb21c4298a544835e18c56d1f; need_bind_tel=false; c_flag=5b991c00b1dd3c936104eb0f28aad784; _ga=GA1.1.1004117102.1681904443; new_user=false; imId=bdd7042bddfede3f6846d40b980161c2; imId_0=bdd7042bddfede3f6846d40b980161c2; imClientId=bdd7042bddfede3f8c4e11c17165661e; imClientId_0=bdd7042bddfede3f8c4e11c17165661e; XSRF-TOKEN=ZNW_26Q9SzGF9lYv6QRPBA; __tlog=1701256347630.50%7C00000000%7C00000000%7Cs_o_007%7Cs_o_007; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1698838424,1700049509,1701256348; UniqueKey=267e69689bc2f92b6bc56763ae71c6f2; liepin_login_valid=0; lt_auth=v%2B9caXUBmlqr4Xjd3GJYsf0f24ihWGya%2FXgK0UgAhd68DvPi4P%2FmQAmPr7EE%2BCoIq0gnI6kzMLf%2BNOr7z3BC7EYV%2FVGnlZ6utf6k1XweTuxlHuyflMXuqsjQQ5wtrXo6ykpgn2si0HU%3D; access_system=C; user_roles=0; user_photo=5f8fa3baf6d1ab58476f324908u.png; user_name=%E8%B5%96%E6%96%87%E4%BD%A9; inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; hpo_role-sec_project=sec_project_liepin; hpo_sec_tenant=0; imApp_0=1; acw_tc=276077ba17012604467485820e70d4da2c9fb1aa8355e3c77ae9c748ee57af; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1701260826; fe_im_socketSequence_new_0=7_6_6; __session_seq=20; __uv_seq=20; __tlg_event_seq=286; fe_im_opened_pages=; fe_im_connectJson_0=%7B%220_267e69689bc2f92b6bc56763ae71c6f2%22%3A%7B%22socketConnect%22%3A%222%22%2C%22connectDomain%22%3A%22liepin.com%22%7D%7D; _ga_54YTJKWN86=GS1.1.1701260819.21.1.1701261828.0.0.0\n",
      "这是第1页，接下来将先等待7秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第11页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第12页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第13页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第14页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第15页，接下来将先等待8秒...然后以继续抓取\n",
      "这是第16页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第17页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第18页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第19页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第20页，接下来将先等待6秒...然后以继续抓取\n"
     ]
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "\n",
    "广告行业_深圳_results = crawl_liepin.crawl(城市=\"深圳\",关键词=\"\",学历='本科',行业='广告',登录cookie=cookie)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0a050083",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "4cdb1bb7",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.link</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22scene%22%3A%22condition%22%2C%22skId%22%...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"recruiterName\":\"郑女士\",\"userId\":...</td>\n",
       "      <td>[现金管理, 财务结算, 记账凭证编制, 报表编制, 用友]</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>https://www.liepin.com/job/1963172317.shtml</td>\n",
       "      <td>深圳-龙岗区</td>\n",
       "      <td>会计助理</td>\n",
       "      <td>63172317</td>\n",
       "      <td>20231125111354</td>\n",
       "      <td>...</td>\n",
       "      <td>07ad883867e2634acaa164b6730366d6</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>A轮</td>\n",
       "      <td>622c114ed5235a3cb077f01a08u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13155323/</td>\n",
       "      <td>青橙数科集团</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>13155323.0</td>\n",
       "      <td>互联网</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22scene%22%3A%22condition%22%2C%22skId%22%...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"recruiterName\":\"唐女士\",\"userId\":...</td>\n",
       "      <td>[公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>https://www.liepin.com/job/1963221469.shtml</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>市场经理</td>\n",
       "      <td>63221469</td>\n",
       "      <td>20231127190756</td>\n",
       "      <td>...</td>\n",
       "      <td>6e60308e0d7e0a5d35b7122fd419b76f</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6247ff3b3247ad31bb6a350808u.png</td>\n",
       "      <td>https://www.liepin.com/company/13165103/</td>\n",
       "      <td>贝克斯数字媒体技术(深圳)有限公司</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>13165103.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22scene%22%3A%22condition%22%2C%22skId%22%...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"recruiterName\":\"范女士\",\"userId\":...</td>\n",
       "      <td>[3个月, 提供转正, 本科, 危机公关, 舆情公关, 舆情监测, 媒介公关]</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/lptjob/61664139</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>财经公关实习生</td>\n",
       "      <td>61664139</td>\n",
       "      <td>20231129100045</td>\n",
       "      <td>...</td>\n",
       "      <td>1943df5a18354eac382af2b636b2f6b0</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5dba58bc47b2f02171b5006702u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/10233189/</td>\n",
       "      <td>友扬企业形象策划(上海)有限公司</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>10233189.0</td>\n",
       "      <td>专业技术服务</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22scene%22%3A%22condition%22%2C%22skId%22%...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"recruiterName\":\"艾女士\",\"userId\":...</td>\n",
       "      <td>[3个月, 本科, 新媒体运营, IT/互联网/软件, 消费品, 科技类, 新闻类, 生活类...</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/lptjob/61674093</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>新媒体运营实习生</td>\n",
       "      <td>61674093</td>\n",
       "      <td>20231128135833</td>\n",
       "      <td>...</td>\n",
       "      <td>2423e8c5e3438d7f40ba94cee1349dff</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6045d2d247efeb69daf7dd0708u.png</td>\n",
       "      <td>https://www.liepin.com/company/8904732/</td>\n",
       "      <td>博雅公关</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>8904732.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22scene%22%3A%22condition%22%2C%22skId%22%...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"recruiterName\":\"艾女士\",\"userId\":...</td>\n",
       "      <td>[3个月, 本科, 办公环境管理, 合同管理, 差旅管理, 考勤管理, 报销管理, 行政采购...</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/lptjob/61425843</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>人事行政实习生</td>\n",
       "      <td>61425843</td>\n",
       "      <td>20231128135833</td>\n",
       "      <td>...</td>\n",
       "      <td>2423e8c5e3438d7f40ba94cee1349dff</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6045d2d247efeb69daf7dd0708u.png</td>\n",
       "      <td>https://www.liepin.com/company/8904732/</td>\n",
       "      <td>博雅公关</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>8904732.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22jobId%22%3A%2256816497%22%2C%22ckId%22%3...</td>\n",
       "      <td>{\"userId\":\"16cb9899cb4154a0410e43a2e1432e2e\",\"...</td>\n",
       "      <td>[DSP广告投放, 亚马逊广告, 程序化广告, 自动化广告]</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/job/1956816497.shtml</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>Ad Operations Supervisor</td>\n",
       "      <td>56816497</td>\n",
       "      <td>20230309101708</td>\n",
       "      <td>...</td>\n",
       "      <td>16cb9899cb4154a0410e43a2e1432e2e</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>5ef7eac6639c8353865e8cfa03u.jpeg</td>\n",
       "      <td>https://www.liepin.com/company/9638001/</td>\n",
       "      <td>上海邑炎信息科技有限公司</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>9638001.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22jobId%22%3A%2256694599%22%2C%22ckId%22%3...</td>\n",
       "      <td>{\"userId\":\"1b2239d60792a8ea1955cba740f0f6b5\",\"...</td>\n",
       "      <td>[活动管理, 文档管理, 会议管理, 考勤管理, 差旅管理, 外联管理, 入职管理, 行政采购]</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/job/1956694599.shtml</td>\n",
       "      <td>深圳-龙岗区</td>\n",
       "      <td>行政助理</td>\n",
       "      <td>56694599</td>\n",
       "      <td>20230411142059</td>\n",
       "      <td>...</td>\n",
       "      <td>1b2239d60792a8ea1955cba740f0f6b5</td>\n",
       "      <td>5f8f9868f6d1ab58476f24a008u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64a881c11369df47ea3f08d107u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/12228757/</td>\n",
       "      <td>深圳市星酷文化传播有限公司</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>12228757.0</td>\n",
       "      <td>广播/影视/录音</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22jobId%22%3A%2256680683%22%2C%22ckId%22%3...</td>\n",
       "      <td>{\"userId\":\"4442289bc64a8221cdb3ebf2cb7ea896\",\"...</td>\n",
       "      <td>[广告投放/流量运营, 观众招募, 人工智能展会推广, 擅长创意策划]</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/job/1956680683.shtml</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>媒介经理/主管（展会项目）</td>\n",
       "      <td>56680683</td>\n",
       "      <td>20230912100756</td>\n",
       "      <td>...</td>\n",
       "      <td>4442289bc64a8221cdb3ebf2cb7ea896</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/9713702/</td>\n",
       "      <td>深圳市人工智能行业协会</td>\n",
       "      <td></td>\n",
       "      <td>9713702.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22jobId%22%3A%2256680381%22%2C%22ckId%22%3...</td>\n",
       "      <td>{\"userId\":\"21e5ecc27a64f485adac2bb5496e2e70\",\"...</td>\n",
       "      <td>[人工智能展会推广, 擅长创意策划, 观众招募, 广告投放/流量运营]</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/job/1956680381.shtml</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>媒介经理/主管（展会项目）</td>\n",
       "      <td>56680381</td>\n",
       "      <td>20230829095211</td>\n",
       "      <td>...</td>\n",
       "      <td>21e5ecc27a64f485adac2bb5496e2e70</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/9713702/</td>\n",
       "      <td>深圳市人工智能行业协会</td>\n",
       "      <td></td>\n",
       "      <td>9713702.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22jobId%22%3A%2256638763%22%2C%22ckId%22%3...</td>\n",
       "      <td>{\"userId\":\"3faff102cf045c0eebcc8717d425c3be\",\"...</td>\n",
       "      <td>[包装设计, 工艺设计, 图纸设计, CorelDRAW, Illustrator]</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>https://www.liepin.com/job/1956638763.shtml</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>包装设计师/包装插画/白酒包装</td>\n",
       "      <td>56638763</td>\n",
       "      <td>20230609154453</td>\n",
       "      <td>...</td>\n",
       "      <td>3faff102cf045c0eebcc8717d425c3be</td>\n",
       "      <td>63fc5f29b032b20d07bd4da003u.jpeg</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13443517/</td>\n",
       "      <td>深圳段高峰设计有限公司</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>13443517.0</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>800 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22scene%22%3A%22condition%22%2C%22skId%22%...   \n",
       "1   %7B%22scene%22%3A%22condition%22%2C%22skId%22%...   \n",
       "2   %7B%22scene%22%3A%22condition%22%2C%22skId%22%...   \n",
       "3   %7B%22scene%22%3A%22condition%22%2C%22skId%22%...   \n",
       "4   %7B%22scene%22%3A%22condition%22%2C%22skId%22%...   \n",
       "..                                                ...   \n",
       "35  %7B%22jobId%22%3A%2256816497%22%2C%22ckId%22%3...   \n",
       "36  %7B%22jobId%22%3A%2256694599%22%2C%22ckId%22%3...   \n",
       "37  %7B%22jobId%22%3A%2256680683%22%2C%22ckId%22%3...   \n",
       "38  %7B%22jobId%22%3A%2256680381%22%2C%22ckId%22%3...   \n",
       "39  %7B%22jobId%22%3A%2256638763%22%2C%22ckId%22%3...   \n",
       "\n",
       "                                           dataParams  \\\n",
       "0   {\"jobKind\":\"2\",\"recruiterName\":\"郑女士\",\"userId\":...   \n",
       "1   {\"jobKind\":\"2\",\"recruiterName\":\"唐女士\",\"userId\":...   \n",
       "2   {\"jobKind\":\"6\",\"recruiterName\":\"范女士\",\"userId\":...   \n",
       "3   {\"jobKind\":\"6\",\"recruiterName\":\"艾女士\",\"userId\":...   \n",
       "4   {\"jobKind\":\"6\",\"recruiterName\":\"艾女士\",\"userId\":...   \n",
       "..                                                ...   \n",
       "35  {\"userId\":\"16cb9899cb4154a0410e43a2e1432e2e\",\"...   \n",
       "36  {\"userId\":\"1b2239d60792a8ea1955cba740f0f6b5\",\"...   \n",
       "37  {\"userId\":\"4442289bc64a8221cdb3ebf2cb7ea896\",\"...   \n",
       "38  {\"userId\":\"21e5ecc27a64f485adac2bb5496e2e70\",\"...   \n",
       "39  {\"userId\":\"3faff102cf045c0eebcc8717d425c3be\",\"...   \n",
       "\n",
       "                                           job.labels job.jobKind  job.topJob  \\\n",
       "0                      [现金管理, 财务结算, 记账凭证编制, 报表编制, 用友]           2        True   \n",
       "1   [公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...           2        True   \n",
       "2             [3个月, 提供转正, 本科, 危机公关, 舆情公关, 舆情监测, 媒介公关]           6       False   \n",
       "3   [3个月, 本科, 新媒体运营, IT/互联网/软件, 消费品, 科技类, 新闻类, 生活类...           6       False   \n",
       "4   [3个月, 本科, 办公环境管理, 合同管理, 差旅管理, 考勤管理, 报销管理, 行政采购...           6       False   \n",
       "..                                                ...         ...         ...   \n",
       "35                     [DSP广告投放, 亚马逊广告, 程序化广告, 自动化广告]           2       False   \n",
       "36   [活动管理, 文档管理, 会议管理, 考勤管理, 差旅管理, 外联管理, 入职管理, 行政采购]           2       False   \n",
       "37                [广告投放/流量运营, 观众招募, 人工智能展会推广, 擅长创意策划]           2       False   \n",
       "38                [人工智能展会推广, 擅长创意策划, 观众招募, 广告投放/流量运营]           2       False   \n",
       "39         [包装设计, 工艺设计, 图纸设计, CorelDRAW, Illustrator]           2       False   \n",
       "\n",
       "                                       job.link  job.dq  \\\n",
       "0   https://www.liepin.com/job/1963172317.shtml  深圳-龙岗区   \n",
       "1   https://www.liepin.com/job/1963221469.shtml  深圳-南山区   \n",
       "2        https://www.liepin.com/lptjob/61664139  深圳-福田区   \n",
       "3        https://www.liepin.com/lptjob/61674093  深圳-南山区   \n",
       "4        https://www.liepin.com/lptjob/61425843  深圳-南山区   \n",
       "..                                          ...     ...   \n",
       "35  https://www.liepin.com/job/1956816497.shtml  深圳-南山区   \n",
       "36  https://www.liepin.com/job/1956694599.shtml  深圳-龙岗区   \n",
       "37  https://www.liepin.com/job/1956680683.shtml  深圳-福田区   \n",
       "38  https://www.liepin.com/job/1956680381.shtml  深圳-福田区   \n",
       "39  https://www.liepin.com/job/1956638763.shtml  深圳-宝安区   \n",
       "\n",
       "                   job.title job.jobId job.refreshTime  ...  \\\n",
       "0                       会计助理  63172317  20231125111354  ...   \n",
       "1                       市场经理  63221469  20231127190756  ...   \n",
       "2                    财经公关实习生  61664139  20231129100045  ...   \n",
       "3                   新媒体运营实习生  61674093  20231128135833  ...   \n",
       "4                    人事行政实习生  61425843  20231128135833  ...   \n",
       "..                       ...       ...             ...  ...   \n",
       "35  Ad Operations Supervisor  56816497  20230309101708  ...   \n",
       "36                      行政助理  56694599  20230411142059  ...   \n",
       "37             媒介经理/主管（展会项目）  56680683  20230912100756  ...   \n",
       "38             媒介经理/主管（展会项目）  56680381  20230829095211  ...   \n",
       "39           包装设计师/包装插画/白酒包装  56638763  20230609154453  ...   \n",
       "\n",
       "               recruiter.recruiterId          recruiter.recruiterPhoto  \\\n",
       "0   07ad883867e2634acaa164b6730366d6   5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "1   6e60308e0d7e0a5d35b7122fd419b76f   5f8f986779c7cc70efbf36c008u.jpg   \n",
       "2   1943df5a18354eac382af2b636b2f6b0   5f8f9865ea60860b75384fa508u.jpg   \n",
       "3   2423e8c5e3438d7f40ba94cee1349dff   5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "4   2423e8c5e3438d7f40ba94cee1349dff   5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "..                               ...                               ...   \n",
       "35  16cb9899cb4154a0410e43a2e1432e2e   5f8f9865ea60860b75384fa508u.jpg   \n",
       "36  1b2239d60792a8ea1955cba740f0f6b5   5f8f9868f6d1ab58476f24a008u.jpg   \n",
       "37  4442289bc64a8221cdb3ebf2cb7ea896   5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "38  21e5ecc27a64f485adac2bb5496e2e70   5f8f9865ea60860b75384fa508u.jpg   \n",
       "39  3faff102cf045c0eebcc8717d425c3be  63fc5f29b032b20d07bd4da003u.jpeg   \n",
       "\n",
       "   comp.compStage                     comp.compLogo  \\\n",
       "0              A轮   622c114ed5235a3cb077f01a08u.jpg   \n",
       "1             NaN   6247ff3b3247ad31bb6a350808u.png   \n",
       "2             NaN   5dba58bc47b2f02171b5006702u.jpg   \n",
       "3             NaN   6045d2d247efeb69daf7dd0708u.png   \n",
       "4             NaN   6045d2d247efeb69daf7dd0708u.png   \n",
       "..            ...                               ...   \n",
       "35          融资未公开  5ef7eac6639c8353865e8cfa03u.jpeg   \n",
       "36            NaN   64a881c11369df47ea3f08d107u.jpg   \n",
       "37            NaN   61b07937d0458d53c627567e02u.jpg   \n",
       "38            NaN   61b07937d0458d53c627567e02u.jpg   \n",
       "39            NaN   61b07937d0458d53c627567e02u.jpg   \n",
       "\n",
       "                                   comp.link      comp.compName  \\\n",
       "0   https://www.liepin.com/company/13155323/             青橙数科集团   \n",
       "1   https://www.liepin.com/company/13165103/  贝克斯数字媒体技术(深圳)有限公司   \n",
       "2   https://www.liepin.com/company/10233189/   友扬企业形象策划(上海)有限公司   \n",
       "3    https://www.liepin.com/company/8904732/               博雅公关   \n",
       "4    https://www.liepin.com/company/8904732/               博雅公关   \n",
       "..                                       ...                ...   \n",
       "35   https://www.liepin.com/company/9638001/       上海邑炎信息科技有限公司   \n",
       "36  https://www.liepin.com/company/12228757/      深圳市星酷文化传播有限公司   \n",
       "37   https://www.liepin.com/company/9713702/        深圳市人工智能行业协会   \n",
       "38   https://www.liepin.com/company/9713702/        深圳市人工智能行业协会   \n",
       "39  https://www.liepin.com/company/13443517/        深圳段高峰设计有限公司   \n",
       "\n",
       "   comp.compScale comp.compId comp.compIndustry job.campusJobKind  \n",
       "0        500-999人  13155323.0               互联网               NaN  \n",
       "1        100-499人  13165103.0          广告/公关/会展               NaN  \n",
       "2          50-99人  10233189.0            专业技术服务                实习  \n",
       "3        500-999人   8904732.0          广告/公关/会展                实习  \n",
       "4        500-999人   8904732.0          广告/公关/会展                实习  \n",
       "..            ...         ...               ...               ...  \n",
       "35       100-499人   9638001.0          广告/公关/会展               NaN  \n",
       "36          1-49人  12228757.0          广播/影视/录音               NaN  \n",
       "37                  9713702.0          广告/公关/会展               NaN  \n",
       "38                  9713702.0          广告/公关/会展               NaN  \n",
       "39          1-49人  13443517.0          广告/公关/会展               NaN  \n",
       "\n",
       "[800 rows x 32 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.DataFrame(广告行业_深圳_results)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ce2276db",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('广告行业_深圳_results.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cc34a218",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4ad38df8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
